/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.201
 Source Server Type    : MySQL
 Source Server Version : 50627
 Source Host           : 192.168.0.201:3306
 Source Schema         : web_generator

 Target Server Type    : MySQL
 Target Server Version : 50627
 File Encoding         : 65001

 Date: 17/03/2020 11:30:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for gen_scheme
-- ----------------------------
DROP TABLE IF EXISTS `gen_scheme`;
CREATE TABLE `gen_scheme` (
  `ID` varchar(64) DEFAULT NULL,
  `NAME` varchar(200) DEFAULT NULL,
  `CATEGORY` text,
  `PACKAGE_NAME` text,
  `MODULE_NAME` varchar(30) DEFAULT NULL,
  `SUB_MODULE_NAME` varchar(30) DEFAULT NULL,
  `FUNCTION_NAME` varchar(200) DEFAULT NULL,
  `FUNCTION_NAME_SIMPLE` varchar(100) DEFAULT NULL,
  `FUNCTION_AUTHOR` varchar(100) DEFAULT NULL,
  `GEN_TABLE_NAMES` text,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYGEN_SCHEME1` (`ID`),
  KEY `IDX_GEN_SCHEME_DEL_FLAGGEN_SCH` (`DEL_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生成方案参数信息定义表,用于保存生成的表结构对象信息';

-- ----------------------------
-- Table structure for gen_table
-- ----------------------------
DROP TABLE IF EXISTS `gen_table`;
CREATE TABLE `gen_table` (
  `ID` varchar(64) DEFAULT NULL,
  `TABLE_NAME` varchar(200) DEFAULT NULL,
  `COMMENTS` text,
  `CLASS_NAME` varchar(100) DEFAULT NULL,
  `PARENT_TABLE` varchar(200) DEFAULT NULL,
  `PARENT_TABLE_FK` varchar(100) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  `CATEGORY_VALUE` varchar(10) DEFAULT NULL,
  `CATEGORY_NAME` varchar(100) DEFAULT NULL,
  `CREATE_FO` varchar(1) DEFAULT NULL,
  `CREATE_AR` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYGEN_TABLE1` (`ID`),
  KEY `IDX_GEN_TABLE_DEL_FLAGGEN_TABL` (`DEL_FLAG`),
  KEY `IDX_GEN_TABLE_NAMEGEN_TABLE` (`TABLE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生成代码的业务,用于保存具体的需要生成的表详情';

-- ----------------------------
-- Records of gen_table
-- ----------------------------
BEGIN;
INSERT INTO `gen_table` VALUES ('2039392184414674542', 'sys_role', '角色信息表', 'Role', '', '', '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0', '010201', '系统参数数据表', '0', '0');
COMMIT;

-- ----------------------------
-- Table structure for gen_table_column
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_column`;
CREATE TABLE `gen_table_column` (
  `ID` varchar(64) DEFAULT NULL,
  `GEN_TABLE_ID` varchar(64) DEFAULT NULL,
  `COLUMN_NAME` varchar(200) DEFAULT NULL,
  `COMMENTS` text,
  `JDBC_TYPE` varchar(100) DEFAULT NULL,
  `JAVA_TYPE` text,
  `JAVA_FIELD` varchar(200) DEFAULT NULL,
  `BASE_JAVA_TYPE` varchar(100) DEFAULT NULL,
  `BASE_JAVA_FIELD` varchar(200) DEFAULT NULL,
  `IS_PK` varchar(1) DEFAULT NULL,
  `IS_NULL` varchar(1) DEFAULT NULL,
  `IS_INSERT` varchar(1) DEFAULT NULL,
  `IS_EDIT` varchar(1) DEFAULT NULL,
  `IS_LIST` varchar(1) DEFAULT NULL,
  `IS_QUERY` varchar(1) DEFAULT NULL,
  `QUERY_TYPE` varchar(200) DEFAULT NULL,
  `SHOW_TYPE` varchar(200) DEFAULT NULL,
  `DICT_TYPE` varchar(200) DEFAULT NULL,
  `SETTINGS` text,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYGEN_TABLE_COLUMN1` (`ID`),
  KEY `IDX_GEN_TABLE_COLUMN_DEL_FLAGG` (`DEL_FLAG`),
  KEY `IDX_GEN_TABLE_COLUMN_NAMEGEN_T` (`COLUMN_NAME`),
  KEY `IDX_GEN_TABLE_COLUMN_SORTGEN_T` (`SORT`),
  KEY `IDX_GEN_TABLE_COLUMN_TABLE_IDG` (`GEN_TABLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生成代码的业务表的字段详情, 用于定义该表结构的列对象信息';

-- ----------------------------
-- Records of gen_table_column
-- ----------------------------
BEGIN;
INSERT INTO `gen_table_column` VALUES ('6127004076600769426', '2039392184414674542', 'ID', 'ID', 'varchar(64)', 'java.lang.String', 'id', 'java.lang.String', 'id', NULL, '1', '1', NULL, NULL, NULL, '=', 'input', '', NULL, 10, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('5793379734161858710', '2039392184414674542', 'PARENT_ID', 'PARENT_ID', 'varchar(64)', 'This', 'parent.id|name', 'java.lang.String', 'parentId', NULL, '1', '1', '1', NULL, NULL, '=', 'treeselect', '', NULL, 20, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('150242522725756918', '2039392184414674542', 'NAME', 'NAME', 'varchar(100)', 'java.lang.String', 'name', 'java.lang.String', 'name', NULL, '1', '1', '1', '1', '1', 'like', 'input', '', NULL, 30, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('4014894749160177683', '2039392184414674542', 'ROLE_TYPE', 'ROLE_TYPE', 'varchar(255)', 'java.lang.String', 'roleType', 'java.lang.String', 'roleType', NULL, '1', '1', '1', NULL, NULL, '=', 'input', '', NULL, 40, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('1397045352977154767', '2039392184414674542', 'STATE', 'STATE', 'bigint(22)', 'java.lang.Long', 'state', 'java.lang.Long', 'state', NULL, '1', '1', '1', NULL, NULL, '=', 'input', '', NULL, 50, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('4130367128208558381', '2039392184414674542', 'SORT', 'SORT', 'bigint(22)', 'java.lang.Long', 'sort', 'java.lang.Long', 'sort', NULL, '1', '1', '1', NULL, NULL, '=', 'input', '', NULL, 60, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('8176042328217381329', '2039392184414674542', 'CREATE_BY', 'CREATE_BY', 'varchar(64)', 'com.unitd.modules.sys.entity.SysUser', 'createBy.id', 'java.lang.String', 'createBy', NULL, '1', '1', NULL, NULL, NULL, '=', 'input', '', NULL, 70, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('7159410926648681752', '2039392184414674542', 'CREATE_DATE', 'CREATE_DATE', 'datetime', 'java.util.Date', 'createDate', 'java.util.Date', 'createDate', NULL, '1', '1', NULL, NULL, NULL, '=', 'dateselect', '', NULL, 80, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('5308118229146553108', '2039392184414674542', 'UPDATE_BY', 'UPDATE_BY', 'varchar(64)', 'com.unitd.modules.sys.entity.SysUser', 'updateBy.id', 'java.lang.String', 'updateBy', NULL, '1', '1', '1', NULL, NULL, '=', 'input', '', NULL, 90, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('340523492024420062', '2039392184414674542', 'UPDATE_DATE', 'UPDATE_DATE', 'datetime', 'java.util.Date', 'updateDate', 'java.util.Date', 'updateDate', NULL, '1', '1', '1', '1', NULL, '=', 'dateselect', '', NULL, 100, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('5354286872353655509', '2039392184414674542', 'REMARKS', 'REMARKS', 'varchar(255)', 'java.lang.String', 'remarks', 'java.lang.String', 'remarks', NULL, '1', '1', '1', '1', NULL, '=', 'textarea', '', NULL, 110, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
INSERT INTO `gen_table_column` VALUES ('2236481419739415019', '2039392184414674542', 'DEL_FLAG', 'DEL_FLAG', 'varchar(1)', 'java.lang.String', 'delFlag', 'java.lang.String', 'delFlag', NULL, '1', '1', NULL, NULL, NULL, '=', 'radiobox', 'del_flag', NULL, 120, '1', '2020-03-16 11:22:09', NULL, NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for gen_template
-- ----------------------------
DROP TABLE IF EXISTS `gen_template`;
CREATE TABLE `gen_template` (
  `ID` varchar(64) DEFAULT NULL,
  `NAME` varchar(200) DEFAULT NULL,
  `CATEGORY` text,
  `FILE_PATH` text,
  `FILE_NAME` varchar(200) DEFAULT NULL,
  `CONTENT` longblob,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYGEN_TEMPLATE1` (`ID`),
  KEY `IDX_GEN_TEMPLATE_DEL_FALGGEN_T` (`DEL_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='生成的代码信息对应的模板文件信息定义表';

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
  `ID` varchar(64) DEFAULT NULL,
  `VALUE` varchar(100) DEFAULT NULL,
  `LABEL` varchar(100) DEFAULT NULL,
  `TYPE` varchar(100) DEFAULT NULL,
  `DESCRIPTION` varchar(100) DEFAULT NULL,
  `PARENT_ID` varchar(64) DEFAULT NULL,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYSYS_DICT1` (`ID`),
  KEY `IDX_SYS_DICT_DEL_FLAGSYS_DICT` (`DEL_FLAG`),
  KEY `IDX_SYS_DICT_LABELSYS_DICT` (`LABEL`),
  KEY `IDX_SYS_DICT_VALUESYS_DICT` (`VALUE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='数据字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict` VALUES ('010101', '010101', '系统配置数据表', 'tableCategory', '系统配置数据表', '0101', 10, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('0102', '0102', '参数信息表', 'tableCategory', '参数信息表', '0', 20, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('010102', '010102', '代码生成配置表', 'tableCategory', '代码生成配置表', '0101', 20, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('1000', 'VOL_', 'VOL', 'tablePrefix', '表名前缀', '0', 10, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('0101', '0101', '配置信息表', 'tableCategory', '配置信息表', '0', 10, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('010201', '010201', '系统参数数据表', 'tableCategory', '系统参数数据表', '0102', 10, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('010202', '010202', '业务参数数据表', 'tableCategory', '业务参数数据表', '0102', 20, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('0103', '0103', '业务信息表', 'tableCategory', '业务信息表', '0', 30, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('010301', '010301', '基本业务信息表', 'tableCategory', '基本业务信息表', '0103', 10, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
INSERT INTO `sys_dict` VALUES ('010302', '010301', '关联业务信息表', 'tableCategory', '关联业务信息表', '0103', 20, '1', '2017-05-17 08:00:00', NULL, NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `ID` varchar(64) DEFAULT NULL,
  `UID` varchar(64) DEFAULT NULL,
  `USERNAME` varchar(50) DEFAULT NULL,
  `CONTENT` text,
  `OPERATION` varchar(250) DEFAULT NULL,
  `METHOD` varchar(200) DEFAULT NULL,
  `PARAMS` longblob,
  `IP` varchar(64) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARY_SYS_LOG` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统日志表';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `ID` varchar(64) DEFAULT NULL,
  `PARENT_ID` varchar(64) DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `TYPE` varchar(2) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `PERMS` varchar(200) DEFAULT NULL,
  `DESCRIPTION` varchar(200) DEFAULT NULL,
  `ICON` varchar(30) DEFAULT NULL,
  `STATE` varchar(1) DEFAULT NULL,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYSYS_MENU1` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES ('200100', '200', '权限管理参数', '-1', NULL, NULL, '权限管理', 'fa fa-eye', '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理', '0');
INSERT INTO `sys_menu` VALUES ('100100', '100', '功能管理', '-1', NULL, NULL, '功能管理', 'fa fa-magic', '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '功能管理', '0');
INSERT INTO `sys_menu` VALUES ('100200', '100', '系统监控', '-1', NULL, NULL, '系统监控', 'fa fa-bar-chart-o', '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '系统监控', '0');
INSERT INTO `sys_menu` VALUES ('100300', '100', '代码生成', '-1', NULL, NULL, '代码生成', 'fa fa-bug', '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '代码生成', '0');
INSERT INTO `sys_menu` VALUES ('100100102', '100100', 'Echarts 测试', '0', '/sys/echarts/map.html', 'sys:echarts:map', 'Echarts图表测试', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, 'Echarts图表测试', '0');
INSERT INTO `sys_menu` VALUES ('200100102', '200100', '用户管理', '0', '/sys/sysUser/list.html', 'sys:sysUser:list', '用户管理', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理', '0');
INSERT INTO `sys_menu` VALUES ('200100104', '200100', '角色管理', '0', '/sys/sysRole/list.html', 'sys:sysRole:list', '角色管理', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理', '0');
INSERT INTO `sys_menu` VALUES ('200100103', '200100', '菜单管理', '0', '/sys/sysMenu/list.htm', 'sys:sysMenu:list', '权限管理', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理', '0');
INSERT INTO `sys_menu` VALUES ('100200102', '100200', '实时监控', '0', '/druid/sql.html', 'sys:monitor:realTime', '实时监控', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '实时监控', '0');
INSERT INTO `sys_menu` VALUES ('100200103', '100200', '操作日志', '0', '/sys/sysLog/list.html', 'sys:sysLog:list', '日志列表', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '日志列表', '0');
INSERT INTO `sys_menu` VALUES ('200100102102', '200100102', '用户管理-->编辑', '1', '/sys/sysUser/edit.html', 'sys:sysUser:edit', '用户管理-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('200100102104', '200100102', '用户管理-->删除', '1', '/sys/sysUser/delete.html', 'sys:sysUser:delete', '用户管理-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->删除', '0');
INSERT INTO `sys_menu` VALUES ('200100102103', '200100102', '用户管理-->查看', '1', '/sys/sysUser/view.html', 'sys:sysUser:view', '用户管理-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->查看', '0');
INSERT INTO `sys_menu` VALUES ('200100104102', '200100104', '角色管理-->编辑', '1', '/sys/sysRole/edit.html', 'sys:sysRole:edit', '角色管理-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('200100104104', '200100104', '角色管理-->删除', '1', '/sys/sysRole/delete.html', 'sys:sysRole:delete', '角色管理-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->删除', '0');
INSERT INTO `sys_menu` VALUES ('200100104103', '200100104', '角色管理-->查看', '1', '/sys/sysRole/view.html', 'sys:sysRole:view', '角色管理-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->查看', '0');
INSERT INTO `sys_menu` VALUES ('200100104105', '200100104', '角色管理-->分配权限', '1', '/sys/sysRole/allot.html', 'sys:sysRole:allot', '角色管理-->分配权限', NULL, '0', 5, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->分配权限', '0');
INSERT INTO `sys_menu` VALUES ('200100103102', '200100103', '菜单管理-->编辑', '1', '/sys/sysMenu/edit.html', 'sys:sysMenu:edit', '菜单管理-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('200100103104', '200100103', '菜单管理-->删除', '1', '/sys/sysMenu/delete.html', 'sys:sysMenu:delete', '菜单管理-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理-->删除', '0');
INSERT INTO `sys_menu` VALUES ('200100103103', '200100103', '菜单管理-->查看', '1', '/sys/sysMenu/view.html', 'sys:sysMenu:view', '菜单管理-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理-->查看', '0');
INSERT INTO `sys_menu` VALUES ('200100102101', '200100102', '用户管理-->新增', '1', '/sys/sysUser/edit.html', 'sys:sysUser:add', '用户管理-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->新增', '0');
INSERT INTO `sys_menu` VALUES ('200100103101', '200100103', '菜单管理-->新增', '1', '/sys/sysMenu/edit.html', 'sys:sysMenu:add', '菜单管理-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '权限管理-->新增', '0');
INSERT INTO `sys_menu` VALUES ('200100104101', '200100104', '角色管理-->新增', '1', '/sys/sysRole/edit.html', 'sys:sysRole:add', '角色管理-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->新增', '0');
INSERT INTO `sys_menu` VALUES ('200100101', '200100', '机构管理', '0', '/sys/sysOrg/list.html', 'sys:sysOrg:list', '机构管理', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理', '0');
INSERT INTO `sys_menu` VALUES ('200100101104', '200100101', '机构管理-->删除', '1', '/sys/sysOrg/delete.html', 'sys:sysOrg:delete', '机构管理-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->删除', '0');
INSERT INTO `sys_menu` VALUES ('200100101103', '200100101', '机构管理-->查看', '1', '/sys/sysOrg/view.html', 'sys:sysOrg:view', '机构管理-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->查看', '0');
INSERT INTO `sys_menu` VALUES ('200100101102', '200100101', '机构管理-->编辑', '1', '/sys/sysOrg/edit.html', 'sys:sysOrg:edit', '机构管理-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('200100101101', '200100101', '机构管理-->新增', '1', '/sys/sysOrg/edit.html', 'sys:sysOrg:add', '机构管理-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->新增', '0');
INSERT INTO `sys_menu` VALUES ('200100101105', '200100101', '机构管理-->分配用户', '1', '/sys/sysOrg/allot.html', 'sys:sysOrg:allot', '机构管理-->分配用户', NULL, '0', 5, '1', '2017-04-03 22:00:37', '0', NULL, '用户管理-->删除', '0');
INSERT INTO `sys_menu` VALUES ('200100102105', '200100102', '用户管理-->分配角色', '1', '/sys/sysUser/allot.html', 'sys:sysUser:allot', '用户管理-->分配角色', NULL, '0', 5, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理-->分配权限', '0');
INSERT INTO `sys_menu` VALUES ('100300101', '100300', '业务表配置', '0', '/gen/genTable/list.html', 'gen:genTable:list', '业务表配置', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '角色管理', '0');
INSERT INTO `sys_menu` VALUES ('100300101101', '100300101', '业务表配置-->新增', '1', '/gen/genTable/edit.html', 'gen:genTable:add', '业务表配置-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '业务表配置-->新增', '0');
INSERT INTO `sys_menu` VALUES ('100300101102', '100300101', '业务表配置-->编辑', '1', '/gen/genTable/edit.html', 'gen:genTable:edit', '业务表配置-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '业务表配置-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('100300101103', '100300101', '业务表配置-->查看', '1', '/gen/genTable/view.html', 'gen:genTable:view', '业务表配置-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '业务表配置-->查看', '0');
INSERT INTO `sys_menu` VALUES ('100300101104', '100300101', '业务表配置-->删除', '1', '/gen/genTable/delete.html', 'gen:genTable:delete', '业务表配置-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '业务表配置-->删除', '0');
INSERT INTO `sys_menu` VALUES ('100300102104', '100300102', '生成方案配置-->删除', '1', '/gen/genScheme/delete.html', 'gen:genScheme:delete', '生成方案配置-->删除', NULL, '0', 4, '1', '2017-04-03 22:00:37', '0', NULL, '生成方案配置-->删除', '0');
INSERT INTO `sys_menu` VALUES ('100300102', '100300', '生成方案配置', '0', '/gen/genScheme/list.html', 'gen:genScheme:list', '生成方案配置', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '生成方案配置', '0');
INSERT INTO `sys_menu` VALUES ('100300102101', '100300102', '生成方案配置-->新增', '1', '/gen/genScheme/edit.html', 'gen:genScheme:add', '生成方案配置-->新增', NULL, '0', 1, '1', '2017-04-03 22:00:37', '0', NULL, '生成方案配置-->新增', '0');
INSERT INTO `sys_menu` VALUES ('100300102102', '100300102', '生成方案配置-->编辑', '1', '/gen/genScheme/edit.html', 'gen:genScheme:edit', '生成方案配置-->编辑', NULL, '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '生成方案配置-->编辑', '0');
INSERT INTO `sys_menu` VALUES ('100300102103', '100300102', '生成方案配置-->查看', '1', '/gen/genScheme/view.html', 'gen:genScheme:view', '生成方案配置-->查看', NULL, '0', 3, '1', '2017-04-03 22:00:37', '0', NULL, '生成方案配置-->查看', '0');
INSERT INTO `sys_menu` VALUES ('100', '-1', '系统管理', '-1', NULL, NULL, '功能管理', 'fa fa-eye', '0', 1, '1', '2017-04-03 22:00:37', '1', '2017-05-27 11:46:10', '功能管理', '0');
INSERT INTO `sys_menu` VALUES ('200', '-1', '参数管理', '-1', NULL, NULL, '功能管理', 'fa fa-magic', '0', 2, '1', '2017-04-03 22:00:37', '0', NULL, '功能管理', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_org`;
CREATE TABLE `sys_org` (
  `ID` varchar(64) DEFAULT NULL,
  `ORG_NO` varchar(10) DEFAULT NULL,
  `ORG_CODE` varchar(32) DEFAULT NULL,
  `BRANCH_CODE` varchar(12) DEFAULT NULL,
  `ORG_NAME` varchar(200) DEFAULT NULL,
  `SHORT_NAME` varchar(100) DEFAULT NULL,
  `ADDRESS` varchar(200) DEFAULT NULL,
  `EN_NAME` varchar(200) DEFAULT NULL,
  `SHORT_EN_NAME` varchar(100) DEFAULT NULL,
  `EN_ADDRESS` varchar(200) DEFAULT NULL,
  `RANK` varchar(3) DEFAULT NULL,
  `SWIFT_CODE` varchar(11) DEFAULT NULL,
  `PARENT_NO` varchar(10) DEFAULT NULL,
  `VIRTUAL_FLAG` varchar(3) DEFAULT NULL,
  `BUSS_FLAG` varchar(3) DEFAULT NULL,
  `DECLARE_FLAG` varchar(3) DEFAULT NULL,
  `FOREIGN_FLAG` varchar(3) DEFAULT NULL,
  `PARITIES_FLAG` varchar(3) DEFAULT NULL,
  `CORP_KIND` varchar(3) DEFAULT NULL,
  `BUSS_CODE_NO` varchar(5) DEFAULT NULL,
  `AREA_ID` varchar(20) DEFAULT NULL,
  `EXECUTE_ORG_NO` varchar(200) DEFAULT NULL,
  `MANAGE_FLAG` varchar(3) DEFAULT NULL,
  `BIG_BANK_NO` varchar(14) DEFAULT NULL,
  `BIG_BANK_NAME` varchar(200) DEFAULT NULL,
  `LINK_MAN` varchar(40) DEFAULT NULL,
  `TELEPHONE` varchar(40) DEFAULT NULL,
  `FAX_NO` varchar(40) DEFAULT NULL,
  `STATE` varchar(3) DEFAULT NULL,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYSYS_ORG1` (`ID`),
  KEY `IDX_SYS_OFFICE_DEL_FLAGSYS_ORG` (`DEL_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构信息表';

-- ----------------------------
-- Records of sys_org
-- ----------------------------
BEGIN;
INSERT INTO `sys_org` VALUES ('1', '1000000000', '1000000000', '123456789012', '总行', '国际业务部', '国际业务部', 'FDASFDSA', 'FDSAFD', 'FDSAFDSA', '0', 'CITIUS33', '-1', '1', '0', '0', '0', '0', '0', NULL, NULL, '1000000000', '1', '4234', '大额行名', '哈哈哈哈', '07317756988', '07317756988', '0', 1, NULL, '2017-03-29 12:11:11', '1', '2017-06-04 09:31:09', NULL, '0');
INSERT INTO `sys_org` VALUES ('2', '1000000001', '1000000001', '100000000111', '国际业务部', '国际业务部', '国际业务部国际业务部国际业务部国际业务部', 'GG', 'GG', 'GGG', '0', 'CITIUS33', '1000000000', '1', '1', '0', '0', '0', '0', NULL, NULL, '1000000001', '1', NULL, NULL, 'GFD', '43545435', '453', '0', 1, '1', '2017-06-01 09:49:39', '1', '2017-06-16 09:36:17', NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `ID` varchar(64) DEFAULT NULL,
  `PARENT_ID` varchar(64) DEFAULT NULL,
  `NAME` varchar(100) DEFAULT NULL,
  `ROLE_TYPE` varchar(255) DEFAULT NULL,
  `STATE` bigint(22) DEFAULT NULL,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYSYS_ROLE1` (`ID`),
  KEY `IDX_SYS_ROLE_DEL_FLAGSYS_ROLE` (`DEL_FLAG`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES ('1', '0', '超级管理员', '0', 0, 1, 'super', '2017-03-29 12:11:11', NULL, NULL, '超级管理员', '0');
INSERT INTO `sys_role` VALUES ('2', '0', '普通管理员', '2', 0, 2, 'admin', '2017-03-29 12:11:11', NULL, NULL, '普通管理员', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `ROLE_ID` varchar(64) DEFAULT NULL,
  `MENU_ID` varchar(64) DEFAULT NULL,
  UNIQUE KEY `PK_SYS_ROLE_MENU_KEY` (`ROLE_ID`,`MENU_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色菜单信息关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES ('1', '1');
INSERT INTO `sys_role_menu` VALUES ('1', '100');
INSERT INTO `sys_role_menu` VALUES ('1', '100100');
INSERT INTO `sys_role_menu` VALUES ('1', '100100101');
INSERT INTO `sys_role_menu` VALUES ('1', '100100101101');
INSERT INTO `sys_role_menu` VALUES ('1', '100100101102');
INSERT INTO `sys_role_menu` VALUES ('1', '100100101103');
INSERT INTO `sys_role_menu` VALUES ('1', '100100101104');
INSERT INTO `sys_role_menu` VALUES ('1', '100100102');
INSERT INTO `sys_role_menu` VALUES ('1', '100200');
INSERT INTO `sys_role_menu` VALUES ('1', '100200101');
INSERT INTO `sys_role_menu` VALUES ('1', '100200102');
INSERT INTO `sys_role_menu` VALUES ('1', '100200103');
INSERT INTO `sys_role_menu` VALUES ('1', '100300');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101101');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101102');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101103');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101104');
INSERT INTO `sys_role_menu` VALUES ('1', '100300101105');
INSERT INTO `sys_role_menu` VALUES ('1', '100300102');
INSERT INTO `sys_role_menu` VALUES ('1', '100300102101');
INSERT INTO `sys_role_menu` VALUES ('1', '100300102102');
INSERT INTO `sys_role_menu` VALUES ('1', '100300102103');
INSERT INTO `sys_role_menu` VALUES ('1', '100300102104');
INSERT INTO `sys_role_menu` VALUES ('1', '2');
INSERT INTO `sys_role_menu` VALUES ('1', '200');
INSERT INTO `sys_role_menu` VALUES ('1', '200100');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101101');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101102');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101103');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101104');
INSERT INTO `sys_role_menu` VALUES ('1', '200100101105');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102101');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102102');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102103');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102104');
INSERT INTO `sys_role_menu` VALUES ('1', '200100102105');
INSERT INTO `sys_role_menu` VALUES ('1', '200100103');
INSERT INTO `sys_role_menu` VALUES ('1', '200100103101');
INSERT INTO `sys_role_menu` VALUES ('1', '200100103102');
INSERT INTO `sys_role_menu` VALUES ('1', '200100103103');
INSERT INTO `sys_role_menu` VALUES ('1', '200100103104');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104101');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104102');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104103');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104104');
INSERT INTO `sys_role_menu` VALUES ('1', '200100104105');
INSERT INTO `sys_role_menu` VALUES ('1', '200200');
INSERT INTO `sys_role_menu` VALUES ('1', '200200101');
INSERT INTO `sys_role_menu` VALUES ('1', '200200101101');
INSERT INTO `sys_role_menu` VALUES ('1', '3');
INSERT INTO `sys_role_menu` VALUES ('1', '300');
INSERT INTO `sys_role_menu` VALUES ('1', '300100');
INSERT INTO `sys_role_menu` VALUES ('1', '300100101');
INSERT INTO `sys_role_menu` VALUES ('1', '300100101101');
INSERT INTO `sys_role_menu` VALUES ('1', '300100101102');
INSERT INTO `sys_role_menu` VALUES ('1', '300100101103');
INSERT INTO `sys_role_menu` VALUES ('1', '300100101104');
INSERT INTO `sys_role_menu` VALUES ('1', '300100201');
INSERT INTO `sys_role_menu` VALUES ('1', '4');
INSERT INTO `sys_role_menu` VALUES ('1', '5');
INSERT INTO `sys_role_menu` VALUES ('2', '-1');
INSERT INTO `sys_role_menu` VALUES ('2', '100');
INSERT INTO `sys_role_menu` VALUES ('2', '100100');
INSERT INTO `sys_role_menu` VALUES ('2', '100100101');
INSERT INTO `sys_role_menu` VALUES ('2', '100100101101');
INSERT INTO `sys_role_menu` VALUES ('2', '100100101102');
INSERT INTO `sys_role_menu` VALUES ('2', '100100101103');
INSERT INTO `sys_role_menu` VALUES ('2', '100100101104');
INSERT INTO `sys_role_menu` VALUES ('2', '100100102');
INSERT INTO `sys_role_menu` VALUES ('2', '100200');
INSERT INTO `sys_role_menu` VALUES ('2', '100200101');
INSERT INTO `sys_role_menu` VALUES ('2', '100200102');
INSERT INTO `sys_role_menu` VALUES ('2', '100200103');
INSERT INTO `sys_role_menu` VALUES ('2', '100300');
INSERT INTO `sys_role_menu` VALUES ('2', '100300101');
INSERT INTO `sys_role_menu` VALUES ('2', '100300101101');
INSERT INTO `sys_role_menu` VALUES ('2', '100300101102');
INSERT INTO `sys_role_menu` VALUES ('2', '100300101103');
INSERT INTO `sys_role_menu` VALUES ('2', '100300101104');
INSERT INTO `sys_role_menu` VALUES ('2', '100300102');
INSERT INTO `sys_role_menu` VALUES ('2', '100300102101');
INSERT INTO `sys_role_menu` VALUES ('2', '100300102102');
INSERT INTO `sys_role_menu` VALUES ('2', '100300102103');
INSERT INTO `sys_role_menu` VALUES ('2', '100300102104');
INSERT INTO `sys_role_menu` VALUES ('2', '200');
INSERT INTO `sys_role_menu` VALUES ('2', '200100');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101101');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101102');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101103');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101104');
INSERT INTO `sys_role_menu` VALUES ('2', '200100101105');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102101');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102102');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102103');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102104');
INSERT INTO `sys_role_menu` VALUES ('2', '200100102105');
INSERT INTO `sys_role_menu` VALUES ('2', '200100103');
INSERT INTO `sys_role_menu` VALUES ('2', '200100103101');
INSERT INTO `sys_role_menu` VALUES ('2', '200100103102');
INSERT INTO `sys_role_menu` VALUES ('2', '200100103103');
INSERT INTO `sys_role_menu` VALUES ('2', '200100103104');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104101');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104102');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104103');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104104');
INSERT INTO `sys_role_menu` VALUES ('2', '200100104105');
INSERT INTO `sys_role_menu` VALUES ('2', '200200');
INSERT INTO `sys_role_menu` VALUES ('2', '200200101');
INSERT INTO `sys_role_menu` VALUES ('2', '200200101101');
INSERT INTO `sys_role_menu` VALUES ('2', '300');
INSERT INTO `sys_role_menu` VALUES ('2', '300100');
INSERT INTO `sys_role_menu` VALUES ('2', '300100101');
INSERT INTO `sys_role_menu` VALUES ('2', '300100101101');
INSERT INTO `sys_role_menu` VALUES ('2', '300100101102');
INSERT INTO `sys_role_menu` VALUES ('2', '300100101103');
INSERT INTO `sys_role_menu` VALUES ('2', '300100101104');
INSERT INTO `sys_role_menu` VALUES ('4', '100');
INSERT INTO `sys_role_menu` VALUES ('4', '100100');
INSERT INTO `sys_role_menu` VALUES ('4', '100100101');
INSERT INTO `sys_role_menu` VALUES ('4', '100100101101');
INSERT INTO `sys_role_menu` VALUES ('4', '100100101102');
INSERT INTO `sys_role_menu` VALUES ('4', '100100101103');
INSERT INTO `sys_role_menu` VALUES ('4', '100100101104');
INSERT INTO `sys_role_menu` VALUES ('4', '100100102');
INSERT INTO `sys_role_menu` VALUES ('4', '100200');
INSERT INTO `sys_role_menu` VALUES ('4', '100200101');
INSERT INTO `sys_role_menu` VALUES ('4', '100200102');
INSERT INTO `sys_role_menu` VALUES ('4', '100200103');
INSERT INTO `sys_role_menu` VALUES ('4', '100300');
INSERT INTO `sys_role_menu` VALUES ('4', '100300101');
INSERT INTO `sys_role_menu` VALUES ('4', '100300101101');
INSERT INTO `sys_role_menu` VALUES ('4', '100300101102');
INSERT INTO `sys_role_menu` VALUES ('4', '100300101103');
INSERT INTO `sys_role_menu` VALUES ('4', '100300101104');
INSERT INTO `sys_role_menu` VALUES ('4', '100300102');
INSERT INTO `sys_role_menu` VALUES ('4', '100300102101');
INSERT INTO `sys_role_menu` VALUES ('4', '100300102102');
INSERT INTO `sys_role_menu` VALUES ('4', '100300102103');
INSERT INTO `sys_role_menu` VALUES ('4', '100300102104');
INSERT INTO `sys_role_menu` VALUES ('4', '200');
INSERT INTO `sys_role_menu` VALUES ('4', '200100');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101101');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101102');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101103');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101104');
INSERT INTO `sys_role_menu` VALUES ('4', '200100101105');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102101');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102102');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102103');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102104');
INSERT INTO `sys_role_menu` VALUES ('4', '200100102105');
INSERT INTO `sys_role_menu` VALUES ('4', '200100103');
INSERT INTO `sys_role_menu` VALUES ('4', '200100103101');
INSERT INTO `sys_role_menu` VALUES ('4', '200100103102');
INSERT INTO `sys_role_menu` VALUES ('4', '200100103103');
INSERT INTO `sys_role_menu` VALUES ('4', '200100103104');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104101');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104102');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104103');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104104');
INSERT INTO `sys_role_menu` VALUES ('4', '200100104105');
INSERT INTO `sys_role_menu` VALUES ('4', '200200');
INSERT INTO `sys_role_menu` VALUES ('4', '200200101');
INSERT INTO `sys_role_menu` VALUES ('4', '200200101101');
INSERT INTO `sys_role_menu` VALUES ('4', '300');
INSERT INTO `sys_role_menu` VALUES ('4', '300100');
INSERT INTO `sys_role_menu` VALUES ('4', '300100101');
INSERT INTO `sys_role_menu` VALUES ('4', '300100101101');
INSERT INTO `sys_role_menu` VALUES ('4', '300100101102');
INSERT INTO `sys_role_menu` VALUES ('4', '300100101103');
INSERT INTO `sys_role_menu` VALUES ('4', '300100101104');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_org
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_org`;
CREATE TABLE `sys_role_org` (
  `ROLE_ID` varchar(64) DEFAULT NULL,
  `ORG_NO` varchar(64) DEFAULT NULL,
  UNIQUE KEY `PK_SYS_ROLE_ORG_KEY` (`ROLE_ID`,`ORG_NO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='机构角色信息关联表';

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `ID` varchar(64) DEFAULT NULL,
  `USER_CODE` varchar(16) DEFAULT NULL,
  `MAIN_CORP_NO` varchar(32) DEFAULT NULL,
  `USER_NAME` varchar(100) DEFAULT NULL,
  `USER_PWD` varchar(100) DEFAULT NULL,
  `ORG_NO` varchar(64) DEFAULT NULL,
  `RANK` varchar(3) DEFAULT NULL,
  `STATE` varchar(1) DEFAULT NULL,
  `PHOTO` varchar(200) DEFAULT NULL,
  `SEX` varchar(10) DEFAULT NULL,
  `PHONE` varchar(50) DEFAULT NULL,
  `ID_CODE` varchar(20) DEFAULT NULL,
  `LOGIN_IP` varchar(100) DEFAULT NULL,
  `LOGIN_DATE` datetime DEFAULT NULL,
  `LOGIN_FLAG` varchar(64) DEFAULT NULL,
  `SORT` bigint(22) DEFAULT NULL,
  `CREATE_BY` varchar(64) DEFAULT NULL,
  `CREATE_DATE` datetime DEFAULT NULL,
  `UPDATE_BY` varchar(64) DEFAULT NULL,
  `UPDATE_DATE` datetime DEFAULT NULL,
  `REMARKS` varchar(255) DEFAULT NULL,
  `DEL_FLAG` varchar(1) DEFAULT NULL,
  UNIQUE KEY `PRIMARYSYS_USER1` (`ID`),
  KEY `IDX_SYS_USER_DEL_FLAGSYS_USER` (`DEL_FLAG`),
  KEY `IDX_SYS_USER_OFFICE_IDSYS_USER` (`ORG_NO`),
  KEY `IDX_SYS_USER_UPDATE_DATESYS_US` (`UPDATE_DATE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='系统用户信息表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES ('2', '020002', '423432', '11111111111111', '4844f6c5ca679413e2787bb8d7787420', '1000000000', '2', '0', NULL, '0', NULL, NULL, '127.0.0.1', '2017-04-09 00:00:00', NULL, 3, NULL, '2016-11-11 11:11:11', '1', '2017-06-04 11:04:52', NULL, '1');
INSERT INTO `sys_user` VALUES ('3', '020003', '423432', 'test3', '46a913c1a244e6fa8edc6aa91a1656c8', '1000000000', '0', '0', NULL, '0', NULL, NULL, '127.0.0.1', '2017-04-09 00:00:00', NULL, 4, NULL, '2016-11-11 11:11:11', NULL, '2016-11-11 11:11:11', NULL, '1');
INSERT INTO `sys_user` VALUES ('1', '010001', '423432', 'admin', '3ad1c0f3793e149e5bfb3014bfa53e06', '1000000000', '2', '0', NULL, '0', NULL, NULL, '192.168.0.17', '2020-03-16 10:44:19', NULL, 1, NULL, '2017-05-15 11:30:02', NULL, '2016-11-11 11:11:11', NULL, '0');
INSERT INTO `sys_user` VALUES ('7', '333333333333', '33333333333', '33333333333', '748890a1f65b070b408803ccb8077465', '1000000001', NULL, '0', NULL, '0', '333333333333', NULL, NULL, NULL, '0', 1, '1', '2017-06-05 21:36:20', NULL, NULL, NULL, '1');
INSERT INTO `sys_user` VALUES ('6', '22222222222222', '22222222', '22222222222222222', '77dc8c788ea769114236a6f6432e401a', '1000000000', NULL, '0', NULL, '0', '432324', NULL, NULL, NULL, '0', 5, '1', '2017-06-05 21:34:45', NULL, NULL, NULL, '1');
INSERT INTO `sys_user` VALUES ('4', '214', NULL, '3213', NULL, NULL, NULL, '0', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, '1', '2017-06-04 11:03:31', NULL, NULL, NULL, '0');
INSERT INTO `sys_user` VALUES ('5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '2017-06-04 20:52:54', NULL, NULL, NULL, '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `USER_ID` varchar(64) DEFAULT NULL,
  `ROLE_ID` varchar(64) DEFAULT NULL,
  UNIQUE KEY `PK_SYS_USER_ROLE_KEY` (`USER_ID`,`ROLE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户角色信息关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES ('1', '1');
INSERT INTO `sys_user_role` VALUES ('1', '2');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
